
package com.tis.database.entitys.promis;

import java.io.Serializable;

import javax.persistence.*;

import org.apache.commons.lang.builder.ToStringBuilder;

import promis.utility.CommonService;

import com.tis.database.dao.ClsInstance;
import com.tis.database.entitys.CommonEntity;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the VW_SYNC_GL_POSTING_DETAILS database table.
 * Credit Note = LC
 * deposit : DP
 * Invoice = IV, 
 * Misc Invoice = LI
 * Receipted = LP
 * Misc Receipted = 80
 */
@Entity
@Table(name=ClsInstance.PROMIS_SCHEMA + ClsInstance.POINTER + "VW_SYNC_GL_POSTING_DETAILS")
@NamedQueries({
	@NamedQuery(name=VwSyncGlPostingDetail.findAll, query="FROM VwSyncGlPostingDetail c"),
	@NamedQuery(name=VwSyncGlPostingDetail.findBySearch, query="FROM VwSyncGlPostingDetail c WHERE 1 = 1 "),
	@NamedQuery(name=VwSyncGlPostingDetail.findByDocumentNo, query="FROM VwSyncGlPostingDetail c WHERE 1 = 1 "),
	@NamedQuery(name=VwSyncGlPostingDetail.findBackLogs, query="FROM VwSyncGlPostingDetail c WHERE 1 = 1 ")
})
public class VwSyncGlPostingDetail  implements Serializable {
	private static final long serialVersionUID = 1L;

	@Transient public static final String findAll = "VwSyncGlPostingDetail_findAll";
	@Transient public static final String findBySearch = "VwSyncGlPostingDetail_findBySearch";
	@Transient public static final String findByDocumentNo = "VwSyncGlPostingDetail_findByDocumentNo";
	@Transient public static final String findBackLogs = "VwSyncGlPostingDetail_findBackLogs";
	
	@Id
	@Column(name="GL_POSTING_DETAILS_ID")
	private String id;

	/**
	 * (Javadoc)
	 * @see java.lang.Object#toString()
	 * Date =Oct 9, 2013 : 11:40:09 AM 
	 * CreateBy=Chatree Siangklom
	 * TODO
	 */
	@Override
	public String toString()
	{
		return ToStringBuilder.reflectionToString(this);
	}
	
	/**
	 * 
	 * Date =Oct 11, 2013 : 4:45:25 PM 
	 * CreateBy=Chatree Siangklom
	 * String
	 * TODO
	 * @return
	 */
	public String getVoucherDateToString() {
		return CommonService.ConvertDateTimeToStringDisplay(getVoucherDate());
	}
	
	/**
	 * 
	 * Date =Oct 11, 2013 : 4:45:29 PM 
	 * CreateBy=Chatree Siangklom
	 * String
	 * TODO
	 * @return
	 */
	public String getCreatedOnToString() {
		return CommonService.ConvertDateTimeToStringDisplay(getCreatedOn());
	}
	
	/**
	 * 
	 * Date =Oct 11, 2013 : 4:45:32 PM 
	 * CreateBy=Chatree Siangklom
	 * String
	 * TODO
	 * @return
	 */
	public String getPostingDateToString() {
		return CommonService.ConvertDateTimeToStringDisplay(getPostingDate());
	}
	
	/**
	 * 
	 * Date =Oct 11, 2013 : 4:48:42 PM 
	 * CreateBy=Chatree Siangklom
	 * String
	 * TODO
	 * @return
	 */
	public String getSyncCreatedOnString() {
		return CommonService.ConvertDateTimeToStringDisplay(getSyncCreatedon());
	}
	
	/**
	 * 
	 * Date =Oct 11, 2013 : 4:49:09 PM 
	 * CreateBy=Chatree Siangklom
	 * String
	 * TODO
	 * @return
	 */
	public String getSyncUpdatedOnString() {
		return CommonService.ConvertDateTimeToStringDisplay(getSyncUpdatedon());
	}
	
	@Column(name="ACCOUNT_CODE")
	private String accountCode;

	@Column(name="ACCOUNT_CODE2")
	private String accountCode2;

	private BigDecimal amount;

	@Column(name="ARTICLE_TYPE")
	private String articleType;

	private String ba;

	@Column(name="BASE_AMOUNT")
	private BigDecimal baseAmount;

	@Column(name="BASE_LINE_DATE")
	private String baseLineDate;

	@Column(name="BATCH_NO")
	private BigDecimal batchNo;

	@Column(name="BOQ_ITEM")
	private String boqItem;

	@Column(name="BOQ_SERIAL")
	private BigDecimal boqSerial;

	@Column(name="BOQ_SERIES")
	private BigDecimal boqSeries;

	@Column(name="BOQ_TYPE")
	private String boqType;

	@Column(name="BRANCH_CODE")
	private BigDecimal branchCode;

	@Column(name="CHARGE_CODE")
	private String chargeCode;

	@Column(name="CHARGE_DESCRIPTION")
	private String chargeDescription;

	@Column(name="CL_OB")
	private String clOb;

	private String company;

	@Column(name="COST_CENTER")
	private String costCenter;

	@Column(name="COST_CODE")
	private String costCode;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name="CREATED_ON")
	private Date createdOn;

	private String currency;

	private String description1;

	@Column(name="DOC_TYPE")
	private String docType;

	@Column(name="DOCUMENT_NO")
	private String documentNo;

	private String dummy1;

	private String dummy2;

	private String dummy3;

	private String dummy4;

	private String dummy5;

	@Column(name="EXP_BATCH_NO")
	private String expBatchNo;
	
	@Column(name="STATUS")
	private String status;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name="EXP_CREATED_ON")
	private Date expCreatedOn;

	@Column(name="EXP_REF_CODE")
	private String expRefCode;

	@Column(name="FILE_ID")
	private BigDecimal fileId;

	@Column(name="FLAG_MANUAL")
	private String flagManual;

	@Column(name="GL_POSTING_SEQ_NUMBER")
	private BigDecimal glPostingSeqNumber;

	@Column(name="IMPORT_INV_REF")
	private String importInvRef;

	private String narration;

	@Column(name="ORG_CODE")
	private String orgCode;

	@Column(name="PO_NO")
	private BigDecimal poNo;

	@Column(name="PO_SEQ_NO")
	private BigDecimal poSeqNo;

	@Column(name="PO_SERIES")
	private String poSeries;

	@Column(name="PO_TYPE")
	private String poType;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name="POSTING_DATE")
	private Date postingDate;

	@Column(name="POSTING_KEY")
	private String postingKey;

	@Column(name="POSTING_NUMBER")
	private BigDecimal postingNumber;

	@Column(name="POSTING_SERIES")
	private String postingSeries;

	private String project;

	@Column(name="REF_DOC_NO")
	private String refDocNo;

	@Column(name="REF_TENANT")
	private String refTenant;

	@Column(name="REFERENCE_CODE")
	private String referenceCode;

	private BigDecimal revision;

	@Column(name="SPECIAL_GL")
	private String specialGl;

	@Column(name="SUB_PROJECT")
	private String subProject;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_EXTERNAL_REF_KEY")
	private String syncExternalRefKey;

	@Column(name="SYNC_EXTERNAL_REF_NO")
	private String syncExternalRefNo;

	@Column(name="SYNC_INSTANCE_NO")
	private String syncInstanceNo;

	@Column(name="SYNC_ISSTAGING")
	private String syncIsstaging;

	@Column(name="SYNC_ISSYNC")
	private String syncIssync;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="UNIT_NO")
	private String unitNo;

	@Column(name="VAT_CODE")
	private String vatCode;

	@Temporal(TemporalType.TIMESTAMP)
	@Column(name="VOUCHER_DATE")
	private Date voucherDate;

	@Column(name="VOUCHER_NUMBER")
	private BigDecimal voucherNumber;

	@Column(name="VOUCHER_SERIES")
	private String voucherSeries;

	@Column(name="VOUCHER_TYPE")
	private String voucherType;
	
	

	/**
	 * @return the id
	 * Date =Oct 9, 2013 : 11:37:42 AM 
	 * CreateBy=Chatree Siangklom
	 * VwSyncGlPostingDetail.java String
	 * TODO
	 */
	public String getId() {
		return id;
	}

	/**
	 * @param id the id to set
	 * Date =Oct 9, 2013 : 11:37:42 AM 
	 * CreateBy=Chatree Siangklom
	 *  VwSyncGlPostingDetail.java String
	 * TODO
	 */
	public void setId(String id) {
		this.id = id;
	}

	/**
	 * @return the status
	 * Date =Oct 9, 2013 : 3:21:17 PM 
	 * CreateBy=Chatree Siangklom
	 * VwSyncGlPostingDetail.java String
	 * TODO
	 */
	public String getStatus() {
		return status;
	}

	/**
	 * @param status the status to set
	 * Date =Oct 9, 2013 : 3:21:17 PM 
	 * CreateBy=Chatree Siangklom
	 *  VwSyncGlPostingDetail.java String
	 * TODO
	 */
	public void setStatus(String status) {
		this.status = status;
	}

	public VwSyncGlPostingDetail() {
	}

	public String getAccountCode() {
		return this.accountCode;
	}

	public void setAccountCode(String accountCode) {
		this.accountCode = accountCode;
	}

	public String getAccountCode2() {
		return this.accountCode2;
	}

	public void setAccountCode2(String accountCode2) {
		this.accountCode2 = accountCode2;
	}

	public BigDecimal getAmount() {
		return this.amount;
	}

	public void setAmount(BigDecimal amount) {
		this.amount = amount;
	}

	public String getArticleType() {
		return this.articleType;
	}

	public void setArticleType(String articleType) {
		this.articleType = articleType;
	}

	public String getBa() {
		return this.ba;
	}

	public void setBa(String ba) {
		this.ba = ba;
	}

	public BigDecimal getBaseAmount() {
		return this.baseAmount;
	}

	public void setBaseAmount(BigDecimal baseAmount) {
		this.baseAmount = baseAmount;
	}

	public String getBaseLineDate() {
		return this.baseLineDate;
	}

	public void setBaseLineDate(String baseLineDate) {
		this.baseLineDate = baseLineDate;
	}

	public BigDecimal getBatchNo() {
		return this.batchNo;
	}

	public void setBatchNo(BigDecimal batchNo) {
		this.batchNo = batchNo;
	}

	public String getBoqItem() {
		return this.boqItem;
	}

	public void setBoqItem(String boqItem) {
		this.boqItem = boqItem;
	}

	public BigDecimal getBoqSerial() {
		return this.boqSerial;
	}

	public void setBoqSerial(BigDecimal boqSerial) {
		this.boqSerial = boqSerial;
	}

	public BigDecimal getBoqSeries() {
		return this.boqSeries;
	}

	public void setBoqSeries(BigDecimal boqSeries) {
		this.boqSeries = boqSeries;
	}

	public String getBoqType() {
		return this.boqType;
	}

	public void setBoqType(String boqType) {
		this.boqType = boqType;
	}

	public BigDecimal getBranchCode() {
		return this.branchCode;
	}

	public void setBranchCode(BigDecimal branchCode) {
		this.branchCode = branchCode;
	}

	public String getChargeCode() {
		return this.chargeCode;
	}

	public void setChargeCode(String chargeCode) {
		this.chargeCode = chargeCode;
	}

	public String getChargeDescription() {
		return this.chargeDescription;
	}

	public void setChargeDescription(String chargeDescription) {
		this.chargeDescription = chargeDescription;
	}

	public String getClOb() {
		return this.clOb;
	}

	public void setClOb(String clOb) {
		this.clOb = clOb;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public String getCostCenter() {
		return this.costCenter;
	}

	public void setCostCenter(String costCenter) {
		this.costCenter = costCenter;
	}

	public String getCostCode() {
		return this.costCode;
	}

	public void setCostCode(String costCode) {
		this.costCode = costCode;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public Date getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(Date createdOn) {
		this.createdOn = createdOn;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	public String getDescription1() {
		return this.description1;
	}

	public void setDescription1(String description1) {
		this.description1 = description1;
	}

	public String getDocType() {
		return this.docType;
	}

	public void setDocType(String docType) {
		this.docType = docType;
	}

	public String getDocumentNo() {
		return this.documentNo;
	}

	public void setDocumentNo(String documentNo) {
		this.documentNo = documentNo;
	}

	public String getDummy1() {
		return this.dummy1;
	}

	public void setDummy1(String dummy1) {
		this.dummy1 = dummy1;
	}

	public String getDummy2() {
		return this.dummy2;
	}

	public void setDummy2(String dummy2) {
		this.dummy2 = dummy2;
	}

	public String getDummy3() {
		return this.dummy3;
	}

	public void setDummy3(String dummy3) {
		this.dummy3 = dummy3;
	}

	public String getDummy4() {
		return this.dummy4;
	}

	public void setDummy4(String dummy4) {
		this.dummy4 = dummy4;
	}

	public String getDummy5() {
		return this.dummy5;
	}

	public void setDummy5(String dummy5) {
		this.dummy5 = dummy5;
	}

	public String getExpBatchNo() {
		return this.expBatchNo;
	}

	public void setExpBatchNo(String expBatchNo) {
		this.expBatchNo = expBatchNo;
	}

	public Date getExpCreatedOn() {
		return this.expCreatedOn;
	}

	public void setExpCreatedOn(Date expCreatedOn) {
		this.expCreatedOn = expCreatedOn;
	}

	public String getExpRefCode() {
		return this.expRefCode;
	}

	public void setExpRefCode(String expRefCode) {
		this.expRefCode = expRefCode;
	}

	public BigDecimal getFileId() {
		return this.fileId;
	}

	public void setFileId(BigDecimal fileId) {
		this.fileId = fileId;
	}

	public String getFlagManual() {
		return this.flagManual;
	}

	public void setFlagManual(String flagManual) {
		this.flagManual = flagManual;
	}

	public BigDecimal getGlPostingSeqNumber() {
		return this.glPostingSeqNumber;
	}

	public void setGlPostingSeqNumber(BigDecimal glPostingSeqNumber) {
		this.glPostingSeqNumber = glPostingSeqNumber;
	}

	public String getImportInvRef() {
		return this.importInvRef;
	}

	public void setImportInvRef(String importInvRef) {
		this.importInvRef = importInvRef;
	}

	public String getNarration() {
		return this.narration;
	}

	public void setNarration(String narration) {
		this.narration = narration;
	}

	public String getOrgCode() {
		return this.orgCode;
	}

	public void setOrgCode(String orgCode) {
		this.orgCode = orgCode;
	}

	public BigDecimal getPoNo() {
		return this.poNo;
	}

	public void setPoNo(BigDecimal poNo) {
		this.poNo = poNo;
	}

	public BigDecimal getPoSeqNo() {
		return this.poSeqNo;
	}

	public void setPoSeqNo(BigDecimal poSeqNo) {
		this.poSeqNo = poSeqNo;
	}

	public String getPoSeries() {
		return this.poSeries;
	}

	public void setPoSeries(String poSeries) {
		this.poSeries = poSeries;
	}

	public String getPoType() {
		return this.poType;
	}

	public void setPoType(String poType) {
		this.poType = poType;
	}

	public Date getPostingDate() {
		return this.postingDate;
	}

	public void setPostingDate(Date postingDate) {
		this.postingDate = postingDate;
	}

	public String getPostingKey() {
		return this.postingKey;
	}

	public void setPostingKey(String postingKey) {
		this.postingKey = postingKey;
	}

	public BigDecimal getPostingNumber() {
		return this.postingNumber;
	}

	public void setPostingNumber(BigDecimal postingNumber) {
		this.postingNumber = postingNumber;
	}

	public String getPostingSeries() {
		return this.postingSeries;
	}

	public void setPostingSeries(String postingSeries) {
		this.postingSeries = postingSeries;
	}

	public String getProject() {
		return this.project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public String getRefDocNo() {
		return this.refDocNo;
	}

	public void setRefDocNo(String refDocNo) {
		this.refDocNo = refDocNo;
	}

	public String getRefTenant() {
		return this.refTenant;
	}

	public void setRefTenant(String refTenant) {
		this.refTenant = refTenant;
	}

	public String getReferenceCode() {
		return this.referenceCode;
	}

	public void setReferenceCode(String referenceCode) {
		this.referenceCode = referenceCode;
	}

	public BigDecimal getRevision() {
		return this.revision;
	}

	public void setRevision(BigDecimal revision) {
		this.revision = revision;
	}

	public String getSpecialGl() {
		return this.specialGl;
	}

	public void setSpecialGl(String specialGl) {
		this.specialGl = specialGl;
	}

	public String getSubProject() {
		return this.subProject;
	}

	public void setSubProject(String subProject) {
		this.subProject = subProject;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncExternalRefKey() {
		return this.syncExternalRefKey;
	}

	public void setSyncExternalRefKey(String syncExternalRefKey) {
		this.syncExternalRefKey = syncExternalRefKey;
	}

	public String getSyncExternalRefNo() {
		return this.syncExternalRefNo;
	}

	public void setSyncExternalRefNo(String syncExternalRefNo) {
		this.syncExternalRefNo = syncExternalRefNo;
	}

	public String getSyncInstanceNo() {
		return this.syncInstanceNo;
	}

	public void setSyncInstanceNo(String syncInstanceNo) {
		this.syncInstanceNo = syncInstanceNo;
	}

	public String getSyncIsstaging() {
		return this.syncIsstaging;
	}

	public void setSyncIsstaging(String syncIsstaging) {
		this.syncIsstaging = syncIsstaging;
	}

	public String getSyncIssync() {
		return this.syncIssync;
	}

	public void setSyncIssync(String syncIssync) {
		this.syncIssync = syncIssync;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getUnitNo() {
		return this.unitNo;
	}

	public void setUnitNo(String unitNo) {
		this.unitNo = unitNo;
	}

	public String getVatCode() {
		return this.vatCode;
	}

	public void setVatCode(String vatCode) {
		this.vatCode = vatCode;
	}

	public Date getVoucherDate() {
		return this.voucherDate;
	}

	public void setVoucherDate(Date voucherDate) {
		this.voucherDate = voucherDate;
	}

	public BigDecimal getVoucherNumber() {
		return this.voucherNumber;
	}

	public void setVoucherNumber(BigDecimal voucherNumber) {
		this.voucherNumber = voucherNumber;
	}

	public String getVoucherSeries() {
		return this.voucherSeries;
	}

	public void setVoucherSeries(String voucherSeries) {
		this.voucherSeries = voucherSeries;
	}

	public String getVoucherType() {
		return this.voucherType;
	}

	public void setVoucherType(String voucherType) {
		this.voucherType = voucherType;
	}

}